QueryDef Object, QueryDefs Collection Summary

   

QueryDef Object

A QueryDef object contains these collections, methods, and properties.

Legend:

Available only in a Microsoft Jet workspace.

Available only in an ODBCDirect workspace.

Collections

Fields
Parameters (default)
Properties

Methods

Cancel
Close
CreateProperty
Execute
OpenRecordset

Properties

CacheSize
Connect
DateCreated
KeepLocal
LastUpdated
LogMessages
MaxRecords
Name
ODBCTimeout
Prepare
RecordsAffected
Replicable
ReturnsRecords
SQL
StillExecuting
Type
Updatable

QueryDefs Collection

A QueryDefs collection appears in each Connection object in an ODBCDirect workspace, and each Database object, and contains these methods and this property.

Methods

Append
Delete
Refresh

Property

Count